TillWorkstationAssignment

Entity Definition

Logical Name : TillWorkstationAssignment
Physical Name : CO_ASGMT_WS_TL

A permanent or temporary assignment of a Till to a particular Workstation, recording where the Till was located for a particular period of time.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
AssignmentStartTransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN_SRT IdentityUUID char(32) TillMovementTransaction(TR_MV_TL)
WorkstationID (FK)(PK) The unique identifier for the WORKSTATION, typically the serial number. ID_WS Identity integer Workstation(AS_WS)
TillID (FK)(PK) The unique identifier for the TENDER RESPOSITORY. ID_RPSTY_TND Identity integer Till(AS_TL)
AssignmentEndTransactionID (FK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN_END IdentityUUID char(32) TillMovementTransaction(TR_MV_TL)

Relationships

Parent Entity Verb Phrase Child Entity
Workstation is assigned TillWorkstationAssignment
TillMovementTransaction ends TillWorkstationAssignment
TillMovementTransaction starts TillWorkstationAssignment
Till is assigned TillWorkstationAssignment

Logical Views containing TillWorkstationAssignment

Logical View
Logical 02400 - Control Transaction Macro View
Logical 02410 - Control Transaction - Sign On Off View
Logical 02420 - Control Transaction - Till Movement View
Logical 02500 - Tender Control Transaction - Macro View
Logical 02520 - Tender Control Transaction - Settlement View
Logical 03140 - Reporting - Store Operations - Workstation View
Logical 03160 - Reporting - Store Operations - Till View
Logical 10120 - Enterprise - Location, WkStn, Operator, Till